Entity DefinitionLogical Name : ShipmentContainer |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| FreightBillID (FK)(PK) | The carrier-assigned shipping document number | ID_BL_FRGT | Identity | integer | FreightBill(DO_BL_FRGT) |
| FreightBillLineNumber (PK) | The line number on the FREIGHT BILL to which this particular shipment container applies. | IC_BL_FRGT | LineNumber | smallint | |
| ContainerTypeCode (FK) | A category of container that defines what it is made of, its type (primarily its material handling category - e.g. 55 gallon drums, pallets, cases, etc.) and its shape. | CD_CNR_TYP | Code | varchar(20) | ContainerType(ID_TYP_CNR) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| ContainerType | validates | ShipmentContainer |
| FreightBill | includes | ShipmentContainer |
| ShipmentContainer | may include | ShipmentContainerMerchandiseLineItem |
| Logical View |
|---|
| Logical 02100 - Item Inventory - Macro View |
| Logical 02130 - Item Inventory - Receiving View |
| Logical 02309 - Retail Transaction Delivery |